Learn how to become a DBA (database administrator) – plus, learn the all the essentials of SQL Server, from the very basics of how it works, to security, high availability, and more. The complete eight-part series can be found below.

SQL Server

Pamela Mooney in SQL Server

High availability in SQL Server – a guide (DBA in training, part eight)

DBAs must make sure data is highly available, and there are many SQL Server high availability options. Pamela Mooney discusses…

19 May 2021 23 min read

SQL Server

Pamela Mooney in SQL Server

The basics of SQL Server internals (DBA in training, part seven)

In this article of the series, Pamela Mooney explains the architecture of SQL Server under the hood, including some query…

28 January 2021 27 min read

Databases

Pamela Mooney in Databases

How to know your server’s limits (DBA in training, part six)

Comparing current performance to baselines helps DBAs know when there’s a problem. In this article, Pamela Mooney describes how to…

10 December 2020 15 min read

SQL Server

Pamela Mooney in SQL Server

SQL Server Backup Strategy: RPO, RTO, Recovery Models, and Restore Types

Build a SQL Server backup strategy from SLA to implementation: understand RPO and RTO, choose the right recovery model (FULL,…

09 November 2020 21 min read

SQL Server

Pamela Mooney in SQL Server

SQL Server Security for DBAs: Authentication, Permissions, Monitoring, and Audit

Comprehensive SQL Server security guide for DBAs – covering physical and data-file security, patching, authentication (Windows vs SQL), server and…

08 October 2020 28 min read

Career

Pamela Mooney in Career

How to know your server environment(s) (DBA in Training, part three)

It doesn’t matter if you become an “accidental DBA” or are actively looking for a database administrator position, you may…

14 September 2020 11 min read

Career

Pamela Mooney in Career

How to prepare for a DBA job interview (DBA in training, part two)

Getting that first job as a DBA is not easy for most of us. In this article, Pamela Mooney explains…

26 August 2020 18 min read

Career

Pamela Mooney in Career

How to become a DBA – the first steps (DBA in Training, part one)

Many people with tech careers did not follow a straight path to get there. In this article, Pamela Mooney gives…

11 August 2020 15 min read